package com.tm.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class SpOrderCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SpOrderCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdIsNull() {
            addCriterion("member_info_id is null");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdIsNotNull() {
            addCriterion("member_info_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdEqualTo(Integer value) {
            addCriterion("member_info_id =", value, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdNotEqualTo(Integer value) {
            addCriterion("member_info_id <>", value, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdGreaterThan(Integer value) {
            addCriterion("member_info_id >", value, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("member_info_id >=", value, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdLessThan(Integer value) {
            addCriterion("member_info_id <", value, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdLessThanOrEqualTo(Integer value) {
            addCriterion("member_info_id <=", value, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdIn(List<Integer> values) {
            addCriterion("member_info_id in", values, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdNotIn(List<Integer> values) {
            addCriterion("member_info_id not in", values, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdBetween(Integer value1, Integer value2) {
            addCriterion("member_info_id between", value1, value2, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andMemberInfoIdNotBetween(Integer value1, Integer value2) {
            addCriterion("member_info_id not between", value1, value2, "memberInfoId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdIsNull() {
            addCriterion("delivery_addr_id is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdIsNotNull() {
            addCriterion("delivery_addr_id is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdEqualTo(Integer value) {
            addCriterion("delivery_addr_id =", value, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdNotEqualTo(Integer value) {
            addCriterion("delivery_addr_id <>", value, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdGreaterThan(Integer value) {
            addCriterion("delivery_addr_id >", value, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("delivery_addr_id >=", value, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdLessThan(Integer value) {
            addCriterion("delivery_addr_id <", value, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdLessThanOrEqualTo(Integer value) {
            addCriterion("delivery_addr_id <=", value, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdIn(List<Integer> values) {
            addCriterion("delivery_addr_id in", values, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdNotIn(List<Integer> values) {
            addCriterion("delivery_addr_id not in", values, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdBetween(Integer value1, Integer value2) {
            addCriterion("delivery_addr_id between", value1, value2, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddrIdNotBetween(Integer value1, Integer value2) {
            addCriterion("delivery_addr_id not between", value1, value2, "deliveryAddrId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andClearCycleIsNull() {
            addCriterion("clear_cycle is null");
            return (Criteria) this;
        }

        public Criteria andClearCycleIsNotNull() {
            addCriterion("clear_cycle is not null");
            return (Criteria) this;
        }

        public Criteria andClearCycleEqualTo(String value) {
            addCriterion("clear_cycle =", value, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleNotEqualTo(String value) {
            addCriterion("clear_cycle <>", value, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleGreaterThan(String value) {
            addCriterion("clear_cycle >", value, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleGreaterThanOrEqualTo(String value) {
            addCriterion("clear_cycle >=", value, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleLessThan(String value) {
            addCriterion("clear_cycle <", value, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleLessThanOrEqualTo(String value) {
            addCriterion("clear_cycle <=", value, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleLike(String value) {
            addCriterion("clear_cycle like", value, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleNotLike(String value) {
            addCriterion("clear_cycle not like", value, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleIn(List<String> values) {
            addCriterion("clear_cycle in", values, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleNotIn(List<String> values) {
            addCriterion("clear_cycle not in", values, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleBetween(String value1, String value2) {
            addCriterion("clear_cycle between", value1, value2, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andClearCycleNotBetween(String value1, String value2) {
            addCriterion("clear_cycle not between", value1, value2, "clearCycle");
            return (Criteria) this;
        }

        public Criteria andCouponsIdIsNull() {
            addCriterion("coupons_id is null");
            return (Criteria) this;
        }

        public Criteria andCouponsIdIsNotNull() {
            addCriterion("coupons_id is not null");
            return (Criteria) this;
        }

        public Criteria andCouponsIdEqualTo(Integer value) {
            addCriterion("coupons_id =", value, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdNotEqualTo(Integer value) {
            addCriterion("coupons_id <>", value, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdGreaterThan(Integer value) {
            addCriterion("coupons_id >", value, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("coupons_id >=", value, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdLessThan(Integer value) {
            addCriterion("coupons_id <", value, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdLessThanOrEqualTo(Integer value) {
            addCriterion("coupons_id <=", value, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdIn(List<Integer> values) {
            addCriterion("coupons_id in", values, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdNotIn(List<Integer> values) {
            addCriterion("coupons_id not in", values, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdBetween(Integer value1, Integer value2) {
            addCriterion("coupons_id between", value1, value2, "couponsId");
            return (Criteria) this;
        }

        public Criteria andCouponsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("coupons_id not between", value1, value2, "couponsId");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(String value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(String value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(String value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(String value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLike(String value) {
            addCriterion("order_type like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotLike(String value) {
            addCriterion("order_type not like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<String> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<String> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(String value1, String value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(String value1, String value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(String value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(String value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(String value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(String value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(String value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(String value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLike(String value) {
            addCriterion("create_time like", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotLike(String value) {
            addCriterion("create_time not like", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<String> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<String> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(String value1, String value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(String value1, String value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andOrderStateIsNull() {
            addCriterion("order_state is null");
            return (Criteria) this;
        }

        public Criteria andOrderStateIsNotNull() {
            addCriterion("order_state is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStateEqualTo(String value) {
            addCriterion("order_state =", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotEqualTo(String value) {
            addCriterion("order_state <>", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateGreaterThan(String value) {
            addCriterion("order_state >", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateGreaterThanOrEqualTo(String value) {
            addCriterion("order_state >=", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLessThan(String value) {
            addCriterion("order_state <", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLessThanOrEqualTo(String value) {
            addCriterion("order_state <=", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLike(String value) {
            addCriterion("order_state like", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotLike(String value) {
            addCriterion("order_state not like", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateIn(List<String> values) {
            addCriterion("order_state in", values, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotIn(List<String> values) {
            addCriterion("order_state not in", values, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateBetween(String value1, String value2) {
            addCriterion("order_state between", value1, value2, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotBetween(String value1, String value2) {
            addCriterion("order_state not between", value1, value2, "orderState");
            return (Criteria) this;
        }

        public Criteria andPayStateIsNull() {
            addCriterion("pay_state is null");
            return (Criteria) this;
        }

        public Criteria andPayStateIsNotNull() {
            addCriterion("pay_state is not null");
            return (Criteria) this;
        }

        public Criteria andPayStateEqualTo(String value) {
            addCriterion("pay_state =", value, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateNotEqualTo(String value) {
            addCriterion("pay_state <>", value, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateGreaterThan(String value) {
            addCriterion("pay_state >", value, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateGreaterThanOrEqualTo(String value) {
            addCriterion("pay_state >=", value, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateLessThan(String value) {
            addCriterion("pay_state <", value, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateLessThanOrEqualTo(String value) {
            addCriterion("pay_state <=", value, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateLike(String value) {
            addCriterion("pay_state like", value, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateNotLike(String value) {
            addCriterion("pay_state not like", value, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateIn(List<String> values) {
            addCriterion("pay_state in", values, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateNotIn(List<String> values) {
            addCriterion("pay_state not in", values, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateBetween(String value1, String value2) {
            addCriterion("pay_state between", value1, value2, "payState");
            return (Criteria) this;
        }

        public Criteria andPayStateNotBetween(String value1, String value2) {
            addCriterion("pay_state not between", value1, value2, "payState");
            return (Criteria) this;
        }

        public Criteria andAllAmountIsNull() {
            addCriterion("all_amount is null");
            return (Criteria) this;
        }

        public Criteria andAllAmountIsNotNull() {
            addCriterion("all_amount is not null");
            return (Criteria) this;
        }

        public Criteria andAllAmountEqualTo(BigDecimal value) {
            addCriterion("all_amount =", value, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountNotEqualTo(BigDecimal value) {
            addCriterion("all_amount <>", value, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountGreaterThan(BigDecimal value) {
            addCriterion("all_amount >", value, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("all_amount >=", value, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountLessThan(BigDecimal value) {
            addCriterion("all_amount <", value, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("all_amount <=", value, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountIn(List<BigDecimal> values) {
            addCriterion("all_amount in", values, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountNotIn(List<BigDecimal> values) {
            addCriterion("all_amount not in", values, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("all_amount between", value1, value2, "allAmount");
            return (Criteria) this;
        }

        public Criteria andAllAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("all_amount not between", value1, value2, "allAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountIsNull() {
            addCriterion("real_amount is null");
            return (Criteria) this;
        }

        public Criteria andRealAmountIsNotNull() {
            addCriterion("real_amount is not null");
            return (Criteria) this;
        }

        public Criteria andRealAmountEqualTo(BigDecimal value) {
            addCriterion("real_amount =", value, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountNotEqualTo(BigDecimal value) {
            addCriterion("real_amount <>", value, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountGreaterThan(BigDecimal value) {
            addCriterion("real_amount >", value, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("real_amount >=", value, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountLessThan(BigDecimal value) {
            addCriterion("real_amount <", value, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("real_amount <=", value, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountIn(List<BigDecimal> values) {
            addCriterion("real_amount in", values, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountNotIn(List<BigDecimal> values) {
            addCriterion("real_amount not in", values, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("real_amount between", value1, value2, "realAmount");
            return (Criteria) this;
        }

        public Criteria andRealAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("real_amount not between", value1, value2, "realAmount");
            return (Criteria) this;
        }

        public Criteria andPayWayIsNull() {
            addCriterion("pay_way is null");
            return (Criteria) this;
        }

        public Criteria andPayWayIsNotNull() {
            addCriterion("pay_way is not null");
            return (Criteria) this;
        }

        public Criteria andPayWayEqualTo(String value) {
            addCriterion("pay_way =", value, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayNotEqualTo(String value) {
            addCriterion("pay_way <>", value, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayGreaterThan(String value) {
            addCriterion("pay_way >", value, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayGreaterThanOrEqualTo(String value) {
            addCriterion("pay_way >=", value, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayLessThan(String value) {
            addCriterion("pay_way <", value, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayLessThanOrEqualTo(String value) {
            addCriterion("pay_way <=", value, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayLike(String value) {
            addCriterion("pay_way like", value, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayNotLike(String value) {
            addCriterion("pay_way not like", value, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayIn(List<String> values) {
            addCriterion("pay_way in", values, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayNotIn(List<String> values) {
            addCriterion("pay_way not in", values, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayBetween(String value1, String value2) {
            addCriterion("pay_way between", value1, value2, "payWay");
            return (Criteria) this;
        }

        public Criteria andPayWayNotBetween(String value1, String value2) {
            addCriterion("pay_way not between", value1, value2, "payWay");
            return (Criteria) this;
        }

        public Criteria andOrderPointIsNull() {
            addCriterion("order_point is null");
            return (Criteria) this;
        }

        public Criteria andOrderPointIsNotNull() {
            addCriterion("order_point is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPointEqualTo(BigDecimal value) {
            addCriterion("order_point =", value, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointNotEqualTo(BigDecimal value) {
            addCriterion("order_point <>", value, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointGreaterThan(BigDecimal value) {
            addCriterion("order_point >", value, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_point >=", value, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointLessThan(BigDecimal value) {
            addCriterion("order_point <", value, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_point <=", value, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointIn(List<BigDecimal> values) {
            addCriterion("order_point in", values, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointNotIn(List<BigDecimal> values) {
            addCriterion("order_point not in", values, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_point between", value1, value2, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPointNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_point not between", value1, value2, "orderPoint");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdIsNull() {
            addCriterion("order_limit_type_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdIsNotNull() {
            addCriterion("order_limit_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdEqualTo(Integer value) {
            addCriterion("order_limit_type_id =", value, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdNotEqualTo(Integer value) {
            addCriterion("order_limit_type_id <>", value, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdGreaterThan(Integer value) {
            addCriterion("order_limit_type_id >", value, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_limit_type_id >=", value, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdLessThan(Integer value) {
            addCriterion("order_limit_type_id <", value, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("order_limit_type_id <=", value, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdIn(List<Integer> values) {
            addCriterion("order_limit_type_id in", values, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdNotIn(List<Integer> values) {
            addCriterion("order_limit_type_id not in", values, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("order_limit_type_id between", value1, value2, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("order_limit_type_id not between", value1, value2, "orderLimitTypeId");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateIsNull() {
            addCriterion("order_limit_date is null");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateIsNotNull() {
            addCriterion("order_limit_date is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateEqualTo(String value) {
            addCriterion("order_limit_date =", value, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateNotEqualTo(String value) {
            addCriterion("order_limit_date <>", value, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateGreaterThan(String value) {
            addCriterion("order_limit_date >", value, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateGreaterThanOrEqualTo(String value) {
            addCriterion("order_limit_date >=", value, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateLessThan(String value) {
            addCriterion("order_limit_date <", value, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateLessThanOrEqualTo(String value) {
            addCriterion("order_limit_date <=", value, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateLike(String value) {
            addCriterion("order_limit_date like", value, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateNotLike(String value) {
            addCriterion("order_limit_date not like", value, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateIn(List<String> values) {
            addCriterion("order_limit_date in", values, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateNotIn(List<String> values) {
            addCriterion("order_limit_date not in", values, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateBetween(String value1, String value2) {
            addCriterion("order_limit_date between", value1, value2, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitDateNotBetween(String value1, String value2) {
            addCriterion("order_limit_date not between", value1, value2, "orderLimitDate");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthIsNull() {
            addCriterion("order_limit_length is null");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthIsNotNull() {
            addCriterion("order_limit_length is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthEqualTo(BigDecimal value) {
            addCriterion("order_limit_length =", value, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthNotEqualTo(BigDecimal value) {
            addCriterion("order_limit_length <>", value, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthGreaterThan(BigDecimal value) {
            addCriterion("order_limit_length >", value, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_limit_length >=", value, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthLessThan(BigDecimal value) {
            addCriterion("order_limit_length <", value, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_limit_length <=", value, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthIn(List<BigDecimal> values) {
            addCriterion("order_limit_length in", values, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthNotIn(List<BigDecimal> values) {
            addCriterion("order_limit_length not in", values, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_limit_length between", value1, value2, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_limit_length not between", value1, value2, "orderLimitLength");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitIsNull() {
            addCriterion("order_limit_length_unit is null");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitIsNotNull() {
            addCriterion("order_limit_length_unit is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitEqualTo(String value) {
            addCriterion("order_limit_length_unit =", value, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitNotEqualTo(String value) {
            addCriterion("order_limit_length_unit <>", value, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitGreaterThan(String value) {
            addCriterion("order_limit_length_unit >", value, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitGreaterThanOrEqualTo(String value) {
            addCriterion("order_limit_length_unit >=", value, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitLessThan(String value) {
            addCriterion("order_limit_length_unit <", value, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitLessThanOrEqualTo(String value) {
            addCriterion("order_limit_length_unit <=", value, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitLike(String value) {
            addCriterion("order_limit_length_unit like", value, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitNotLike(String value) {
            addCriterion("order_limit_length_unit not like", value, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitIn(List<String> values) {
            addCriterion("order_limit_length_unit in", values, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitNotIn(List<String> values) {
            addCriterion("order_limit_length_unit not in", values, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitBetween(String value1, String value2) {
            addCriterion("order_limit_length_unit between", value1, value2, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andOrderLimitLengthUnitNotBetween(String value1, String value2) {
            addCriterion("order_limit_length_unit not between", value1, value2, "orderLimitLengthUnit");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdIsNull() {
            addCriterion("audit_user_id is null");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdIsNotNull() {
            addCriterion("audit_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdEqualTo(Integer value) {
            addCriterion("audit_user_id =", value, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdNotEqualTo(Integer value) {
            addCriterion("audit_user_id <>", value, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdGreaterThan(Integer value) {
            addCriterion("audit_user_id >", value, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("audit_user_id >=", value, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdLessThan(Integer value) {
            addCriterion("audit_user_id <", value, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("audit_user_id <=", value, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdIn(List<Integer> values) {
            addCriterion("audit_user_id in", values, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdNotIn(List<Integer> values) {
            addCriterion("audit_user_id not in", values, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdBetween(Integer value1, Integer value2) {
            addCriterion("audit_user_id between", value1, value2, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("audit_user_id not between", value1, value2, "auditUserId");
            return (Criteria) this;
        }

        public Criteria andAuditTimeIsNull() {
            addCriterion("audit_time is null");
            return (Criteria) this;
        }

        public Criteria andAuditTimeIsNotNull() {
            addCriterion("audit_time is not null");
            return (Criteria) this;
        }

        public Criteria andAuditTimeEqualTo(String value) {
            addCriterion("audit_time =", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeNotEqualTo(String value) {
            addCriterion("audit_time <>", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeGreaterThan(String value) {
            addCriterion("audit_time >", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeGreaterThanOrEqualTo(String value) {
            addCriterion("audit_time >=", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeLessThan(String value) {
            addCriterion("audit_time <", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeLessThanOrEqualTo(String value) {
            addCriterion("audit_time <=", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeLike(String value) {
            addCriterion("audit_time like", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeNotLike(String value) {
            addCriterion("audit_time not like", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeIn(List<String> values) {
            addCriterion("audit_time in", values, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeNotIn(List<String> values) {
            addCriterion("audit_time not in", values, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeBetween(String value1, String value2) {
            addCriterion("audit_time between", value1, value2, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeNotBetween(String value1, String value2) {
            addCriterion("audit_time not between", value1, value2, "auditTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdIsNull() {
            addCriterion("order_cancel_reason_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdIsNotNull() {
            addCriterion("order_cancel_reason_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdEqualTo(Integer value) {
            addCriterion("order_cancel_reason_id =", value, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdNotEqualTo(Integer value) {
            addCriterion("order_cancel_reason_id <>", value, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdGreaterThan(Integer value) {
            addCriterion("order_cancel_reason_id >", value, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_cancel_reason_id >=", value, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdLessThan(Integer value) {
            addCriterion("order_cancel_reason_id <", value, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdLessThanOrEqualTo(Integer value) {
            addCriterion("order_cancel_reason_id <=", value, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdIn(List<Integer> values) {
            addCriterion("order_cancel_reason_id in", values, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdNotIn(List<Integer> values) {
            addCriterion("order_cancel_reason_id not in", values, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdBetween(Integer value1, Integer value2) {
            addCriterion("order_cancel_reason_id between", value1, value2, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelReasonIdNotBetween(Integer value1, Integer value2) {
            addCriterion("order_cancel_reason_id not between", value1, value2, "orderCancelReasonId");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesIsNull() {
            addCriterion("order_cancel_notes is null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesIsNotNull() {
            addCriterion("order_cancel_notes is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesEqualTo(String value) {
            addCriterion("order_cancel_notes =", value, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesNotEqualTo(String value) {
            addCriterion("order_cancel_notes <>", value, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesGreaterThan(String value) {
            addCriterion("order_cancel_notes >", value, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesGreaterThanOrEqualTo(String value) {
            addCriterion("order_cancel_notes >=", value, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesLessThan(String value) {
            addCriterion("order_cancel_notes <", value, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesLessThanOrEqualTo(String value) {
            addCriterion("order_cancel_notes <=", value, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesLike(String value) {
            addCriterion("order_cancel_notes like", value, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesNotLike(String value) {
            addCriterion("order_cancel_notes not like", value, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesIn(List<String> values) {
            addCriterion("order_cancel_notes in", values, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesNotIn(List<String> values) {
            addCriterion("order_cancel_notes not in", values, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesBetween(String value1, String value2) {
            addCriterion("order_cancel_notes between", value1, value2, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelNotesNotBetween(String value1, String value2) {
            addCriterion("order_cancel_notes not between", value1, value2, "orderCancelNotes");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeIsNull() {
            addCriterion("order_cancel_time is null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeIsNotNull() {
            addCriterion("order_cancel_time is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeEqualTo(String value) {
            addCriterion("order_cancel_time =", value, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeNotEqualTo(String value) {
            addCriterion("order_cancel_time <>", value, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeGreaterThan(String value) {
            addCriterion("order_cancel_time >", value, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeGreaterThanOrEqualTo(String value) {
            addCriterion("order_cancel_time >=", value, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeLessThan(String value) {
            addCriterion("order_cancel_time <", value, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeLessThanOrEqualTo(String value) {
            addCriterion("order_cancel_time <=", value, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeLike(String value) {
            addCriterion("order_cancel_time like", value, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeNotLike(String value) {
            addCriterion("order_cancel_time not like", value, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeIn(List<String> values) {
            addCriterion("order_cancel_time in", values, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeNotIn(List<String> values) {
            addCriterion("order_cancel_time not in", values, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeBetween(String value1, String value2) {
            addCriterion("order_cancel_time between", value1, value2, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelTimeNotBetween(String value1, String value2) {
            addCriterion("order_cancel_time not between", value1, value2, "orderCancelTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeIsNull() {
            addCriterion("order_close_time is null");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeIsNotNull() {
            addCriterion("order_close_time is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeEqualTo(String value) {
            addCriterion("order_close_time =", value, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeNotEqualTo(String value) {
            addCriterion("order_close_time <>", value, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeGreaterThan(String value) {
            addCriterion("order_close_time >", value, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeGreaterThanOrEqualTo(String value) {
            addCriterion("order_close_time >=", value, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeLessThan(String value) {
            addCriterion("order_close_time <", value, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeLessThanOrEqualTo(String value) {
            addCriterion("order_close_time <=", value, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeLike(String value) {
            addCriterion("order_close_time like", value, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeNotLike(String value) {
            addCriterion("order_close_time not like", value, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeIn(List<String> values) {
            addCriterion("order_close_time in", values, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeNotIn(List<String> values) {
            addCriterion("order_close_time not in", values, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeBetween(String value1, String value2) {
            addCriterion("order_close_time between", value1, value2, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCloseTimeNotBetween(String value1, String value2) {
            addCriterion("order_close_time not between", value1, value2, "orderCloseTime");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserIsNull() {
            addCriterion("order_cancel_user is null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserIsNotNull() {
            addCriterion("order_cancel_user is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserEqualTo(String value) {
            addCriterion("order_cancel_user =", value, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserNotEqualTo(String value) {
            addCriterion("order_cancel_user <>", value, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserGreaterThan(String value) {
            addCriterion("order_cancel_user >", value, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserGreaterThanOrEqualTo(String value) {
            addCriterion("order_cancel_user >=", value, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserLessThan(String value) {
            addCriterion("order_cancel_user <", value, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserLessThanOrEqualTo(String value) {
            addCriterion("order_cancel_user <=", value, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserLike(String value) {
            addCriterion("order_cancel_user like", value, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserNotLike(String value) {
            addCriterion("order_cancel_user not like", value, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserIn(List<String> values) {
            addCriterion("order_cancel_user in", values, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserNotIn(List<String> values) {
            addCriterion("order_cancel_user not in", values, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserBetween(String value1, String value2) {
            addCriterion("order_cancel_user between", value1, value2, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCancelUserNotBetween(String value1, String value2) {
            addCriterion("order_cancel_user not between", value1, value2, "orderCancelUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserIsNull() {
            addCriterion("order_close_user is null");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserIsNotNull() {
            addCriterion("order_close_user is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserEqualTo(String value) {
            addCriterion("order_close_user =", value, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserNotEqualTo(String value) {
            addCriterion("order_close_user <>", value, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserGreaterThan(String value) {
            addCriterion("order_close_user >", value, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserGreaterThanOrEqualTo(String value) {
            addCriterion("order_close_user >=", value, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserLessThan(String value) {
            addCriterion("order_close_user <", value, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserLessThanOrEqualTo(String value) {
            addCriterion("order_close_user <=", value, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserLike(String value) {
            addCriterion("order_close_user like", value, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserNotLike(String value) {
            addCriterion("order_close_user not like", value, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserIn(List<String> values) {
            addCriterion("order_close_user in", values, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserNotIn(List<String> values) {
            addCriterion("order_close_user not in", values, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserBetween(String value1, String value2) {
            addCriterion("order_close_user between", value1, value2, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCloseUserNotBetween(String value1, String value2) {
            addCriterion("order_close_user not between", value1, value2, "orderCloseUser");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeIsNull() {
            addCriterion("order_check_time is null");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeIsNotNull() {
            addCriterion("order_check_time is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeEqualTo(String value) {
            addCriterion("order_check_time =", value, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeNotEqualTo(String value) {
            addCriterion("order_check_time <>", value, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeGreaterThan(String value) {
            addCriterion("order_check_time >", value, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeGreaterThanOrEqualTo(String value) {
            addCriterion("order_check_time >=", value, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeLessThan(String value) {
            addCriterion("order_check_time <", value, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeLessThanOrEqualTo(String value) {
            addCriterion("order_check_time <=", value, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeLike(String value) {
            addCriterion("order_check_time like", value, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeNotLike(String value) {
            addCriterion("order_check_time not like", value, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeIn(List<String> values) {
            addCriterion("order_check_time in", values, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeNotIn(List<String> values) {
            addCriterion("order_check_time not in", values, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeBetween(String value1, String value2) {
            addCriterion("order_check_time between", value1, value2, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andOrderCheckTimeNotBetween(String value1, String value2) {
            addCriterion("order_check_time not between", value1, value2, "orderCheckTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeIsNull() {
            addCriterion("paid_time is null");
            return (Criteria) this;
        }

        public Criteria andPaidTimeIsNotNull() {
            addCriterion("paid_time is not null");
            return (Criteria) this;
        }

        public Criteria andPaidTimeEqualTo(String value) {
            addCriterion("paid_time =", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeNotEqualTo(String value) {
            addCriterion("paid_time <>", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeGreaterThan(String value) {
            addCriterion("paid_time >", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeGreaterThanOrEqualTo(String value) {
            addCriterion("paid_time >=", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeLessThan(String value) {
            addCriterion("paid_time <", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeLessThanOrEqualTo(String value) {
            addCriterion("paid_time <=", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeLike(String value) {
            addCriterion("paid_time like", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeNotLike(String value) {
            addCriterion("paid_time not like", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeIn(List<String> values) {
            addCriterion("paid_time in", values, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeNotIn(List<String> values) {
            addCriterion("paid_time not in", values, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeBetween(String value1, String value2) {
            addCriterion("paid_time between", value1, value2, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeNotBetween(String value1, String value2) {
            addCriterion("paid_time not between", value1, value2, "paidTime");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeIsNull() {
            addCriterion("order_logistic_fee is null");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeIsNotNull() {
            addCriterion("order_logistic_fee is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeEqualTo(BigDecimal value) {
            addCriterion("order_logistic_fee =", value, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeNotEqualTo(BigDecimal value) {
            addCriterion("order_logistic_fee <>", value, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeGreaterThan(BigDecimal value) {
            addCriterion("order_logistic_fee >", value, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_logistic_fee >=", value, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeLessThan(BigDecimal value) {
            addCriterion("order_logistic_fee <", value, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_logistic_fee <=", value, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeIn(List<BigDecimal> values) {
            addCriterion("order_logistic_fee in", values, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeNotIn(List<BigDecimal> values) {
            addCriterion("order_logistic_fee not in", values, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_logistic_fee between", value1, value2, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderLogisticFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_logistic_fee not between", value1, value2, "orderLogisticFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeIsNull() {
            addCriterion("order_insurance_fee is null");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeIsNotNull() {
            addCriterion("order_insurance_fee is not null");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeEqualTo(BigDecimal value) {
            addCriterion("order_insurance_fee =", value, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeNotEqualTo(BigDecimal value) {
            addCriterion("order_insurance_fee <>", value, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeGreaterThan(BigDecimal value) {
            addCriterion("order_insurance_fee >", value, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_insurance_fee >=", value, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeLessThan(BigDecimal value) {
            addCriterion("order_insurance_fee <", value, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_insurance_fee <=", value, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeIn(List<BigDecimal> values) {
            addCriterion("order_insurance_fee in", values, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeNotIn(List<BigDecimal> values) {
            addCriterion("order_insurance_fee not in", values, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_insurance_fee between", value1, value2, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andOrderInsuranceFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_insurance_fee not between", value1, value2, "orderInsuranceFee");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberIsNull() {
            addCriterion("pay_serial_number is null");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberIsNotNull() {
            addCriterion("pay_serial_number is not null");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberEqualTo(String value) {
            addCriterion("pay_serial_number =", value, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberNotEqualTo(String value) {
            addCriterion("pay_serial_number <>", value, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberGreaterThan(String value) {
            addCriterion("pay_serial_number >", value, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberGreaterThanOrEqualTo(String value) {
            addCriterion("pay_serial_number >=", value, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberLessThan(String value) {
            addCriterion("pay_serial_number <", value, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberLessThanOrEqualTo(String value) {
            addCriterion("pay_serial_number <=", value, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberLike(String value) {
            addCriterion("pay_serial_number like", value, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberNotLike(String value) {
            addCriterion("pay_serial_number not like", value, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberIn(List<String> values) {
            addCriterion("pay_serial_number in", values, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberNotIn(List<String> values) {
            addCriterion("pay_serial_number not in", values, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberBetween(String value1, String value2) {
            addCriterion("pay_serial_number between", value1, value2, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andPaySerialNumberNotBetween(String value1, String value2) {
            addCriterion("pay_serial_number not between", value1, value2, "paySerialNumber");
            return (Criteria) this;
        }

        public Criteria andIpAddressIsNull() {
            addCriterion("ip_address is null");
            return (Criteria) this;
        }

        public Criteria andIpAddressIsNotNull() {
            addCriterion("ip_address is not null");
            return (Criteria) this;
        }

        public Criteria andIpAddressEqualTo(String value) {
            addCriterion("ip_address =", value, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressNotEqualTo(String value) {
            addCriterion("ip_address <>", value, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressGreaterThan(String value) {
            addCriterion("ip_address >", value, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ip_address >=", value, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressLessThan(String value) {
            addCriterion("ip_address <", value, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressLessThanOrEqualTo(String value) {
            addCriterion("ip_address <=", value, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressLike(String value) {
            addCriterion("ip_address like", value, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressNotLike(String value) {
            addCriterion("ip_address not like", value, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressIn(List<String> values) {
            addCriterion("ip_address in", values, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressNotIn(List<String> values) {
            addCriterion("ip_address not in", values, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressBetween(String value1, String value2) {
            addCriterion("ip_address between", value1, value2, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andIpAddressNotBetween(String value1, String value2) {
            addCriterion("ip_address not between", value1, value2, "ipAddress");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberIsNull() {
            addCriterion("waybill_number is null");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberIsNotNull() {
            addCriterion("waybill_number is not null");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberEqualTo(String value) {
            addCriterion("waybill_number =", value, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberNotEqualTo(String value) {
            addCriterion("waybill_number <>", value, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberGreaterThan(String value) {
            addCriterion("waybill_number >", value, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberGreaterThanOrEqualTo(String value) {
            addCriterion("waybill_number >=", value, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberLessThan(String value) {
            addCriterion("waybill_number <", value, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberLessThanOrEqualTo(String value) {
            addCriterion("waybill_number <=", value, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberLike(String value) {
            addCriterion("waybill_number like", value, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberNotLike(String value) {
            addCriterion("waybill_number not like", value, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberIn(List<String> values) {
            addCriterion("waybill_number in", values, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberNotIn(List<String> values) {
            addCriterion("waybill_number not in", values, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberBetween(String value1, String value2) {
            addCriterion("waybill_number between", value1, value2, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andWaybillNumberNotBetween(String value1, String value2) {
            addCriterion("waybill_number not between", value1, value2, "waybillNumber");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNull() {
            addCriterion("is_delete is null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNotNull() {
            addCriterion("is_delete is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteEqualTo(String value) {
            addCriterion("is_delete =", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotEqualTo(String value) {
            addCriterion("is_delete <>", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThan(String value) {
            addCriterion("is_delete >", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThanOrEqualTo(String value) {
            addCriterion("is_delete >=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThan(String value) {
            addCriterion("is_delete <", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThanOrEqualTo(String value) {
            addCriterion("is_delete <=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLike(String value) {
            addCriterion("is_delete like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotLike(String value) {
            addCriterion("is_delete not like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIn(List<String> values) {
            addCriterion("is_delete in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotIn(List<String> values) {
            addCriterion("is_delete not in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteBetween(String value1, String value2) {
            addCriterion("is_delete between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotBetween(String value1, String value2) {
            addCriterion("is_delete not between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNull() {
            addCriterion("add_time is null");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNotNull() {
            addCriterion("add_time is not null");
            return (Criteria) this;
        }

        public Criteria andAddTimeEqualTo(String value) {
            addCriterion("add_time =", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotEqualTo(String value) {
            addCriterion("add_time <>", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThan(String value) {
            addCriterion("add_time >", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThanOrEqualTo(String value) {
            addCriterion("add_time >=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThan(String value) {
            addCriterion("add_time <", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThanOrEqualTo(String value) {
            addCriterion("add_time <=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLike(String value) {
            addCriterion("add_time like", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotLike(String value) {
            addCriterion("add_time not like", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeIn(List<String> values) {
            addCriterion("add_time in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotIn(List<String> values) {
            addCriterion("add_time not in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeBetween(String value1, String value2) {
            addCriterion("add_time between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotBetween(String value1, String value2) {
            addCriterion("add_time not between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddUserIdIsNull() {
            addCriterion("add_user_id is null");
            return (Criteria) this;
        }

        public Criteria andAddUserIdIsNotNull() {
            addCriterion("add_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andAddUserIdEqualTo(Integer value) {
            addCriterion("add_user_id =", value, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdNotEqualTo(Integer value) {
            addCriterion("add_user_id <>", value, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdGreaterThan(Integer value) {
            addCriterion("add_user_id >", value, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("add_user_id >=", value, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdLessThan(Integer value) {
            addCriterion("add_user_id <", value, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("add_user_id <=", value, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdIn(List<Integer> values) {
            addCriterion("add_user_id in", values, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdNotIn(List<Integer> values) {
            addCriterion("add_user_id not in", values, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdBetween(Integer value1, Integer value2) {
            addCriterion("add_user_id between", value1, value2, "addUserId");
            return (Criteria) this;
        }

        public Criteria andAddUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("add_user_id not between", value1, value2, "addUserId");
            return (Criteria) this;
        }

        public Criteria andEditTimeIsNull() {
            addCriterion("edit_time is null");
            return (Criteria) this;
        }

        public Criteria andEditTimeIsNotNull() {
            addCriterion("edit_time is not null");
            return (Criteria) this;
        }

        public Criteria andEditTimeEqualTo(String value) {
            addCriterion("edit_time =", value, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeNotEqualTo(String value) {
            addCriterion("edit_time <>", value, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeGreaterThan(String value) {
            addCriterion("edit_time >", value, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeGreaterThanOrEqualTo(String value) {
            addCriterion("edit_time >=", value, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeLessThan(String value) {
            addCriterion("edit_time <", value, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeLessThanOrEqualTo(String value) {
            addCriterion("edit_time <=", value, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeLike(String value) {
            addCriterion("edit_time like", value, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeNotLike(String value) {
            addCriterion("edit_time not like", value, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeIn(List<String> values) {
            addCriterion("edit_time in", values, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeNotIn(List<String> values) {
            addCriterion("edit_time not in", values, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeBetween(String value1, String value2) {
            addCriterion("edit_time between", value1, value2, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditTimeNotBetween(String value1, String value2) {
            addCriterion("edit_time not between", value1, value2, "editTime");
            return (Criteria) this;
        }

        public Criteria andEditUserIdIsNull() {
            addCriterion("edit_user_id is null");
            return (Criteria) this;
        }

        public Criteria andEditUserIdIsNotNull() {
            addCriterion("edit_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andEditUserIdEqualTo(Integer value) {
            addCriterion("edit_user_id =", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdNotEqualTo(Integer value) {
            addCriterion("edit_user_id <>", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdGreaterThan(Integer value) {
            addCriterion("edit_user_id >", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("edit_user_id >=", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdLessThan(Integer value) {
            addCriterion("edit_user_id <", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("edit_user_id <=", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdIn(List<Integer> values) {
            addCriterion("edit_user_id in", values, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdNotIn(List<Integer> values) {
            addCriterion("edit_user_id not in", values, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdBetween(Integer value1, Integer value2) {
            addCriterion("edit_user_id between", value1, value2, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("edit_user_id not between", value1, value2, "editUserId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}